<?php 
/**
*comment表的操作类，继承基础模型类
*/
class commentModel extends model{
	
	/**
	*添加留言
	*/
	public function insert(){
		//输入过滤
		$this->filter(array('poster','mail','comment'),'htmlspecialchars');
		$this->filter(array('comment'),'nl2br');
		//接收输入数据
		$data['poster']=$_POST['poster'];
		$data['mail']=$_POST['mail'];
		$data['comment']=$_POST['comment'];
		//为其他字段赋值
		$data['reply']='';
		$data['date']=date('Y-m-d H:i:s');
		$data['ip']=$_SERVER['REMOTE_ADDR'];
		//拼接SQL语句
		$sql="insert into comment set ";
		foreach($data as $k=>$v){
			$sql.="$k=:$k,";
		}
		$sql=rtrim($sql,',');//删除最右边逗号
		//通过预处理执行SQL
		$this->db->execute($sql,$data,$flag);
		//返回是否执行成功
		return $flag;
		//执行SQL语句
		//return $this->db->query($sql);;
	}
	/**
	*留言列表
	*/
	public function getAll($limit){
		//获得排序参数
		$order='';
		if(isset($_GET['sort']) && $_GET['sort']=='desc'){
			$order=' order by id desc';
		}
		//拼接SQL
		$sql="select poster,comment,date,reply from comment $order limit $limit";
		//查询结果
		$data=$this->db->fetchAll($sql);
		return $data;
	}
	/**
	*留言总数
	*/
	public function getNumber(){
		$data=  $this->db->fetchRow("select count(*) from comment");
		return $data['count(*)'];
	}
}
?>